This Analysis Model is used for: Revenue Recognition . There is a list of Analysis Models pre-packaged and delivered as a part of Analysis Models - Power BI, and you can refer to them here.
The primary objective of the Revenue Recognition Analysis Model is to generate visualizations by integrating actual revenue recognition data with planned values from revenue recognition forecasts. The model supports multi-company, multi-currency and multi-calendar analysis. Additionally, for companies or groups following multiple accounting standards, it enables the analysis and visualization of differences between them. Measures available in both periodic and accumulated formats are translated to different currency using period amounts, while accumulated amounts represent the aggregation of already translated period amounts.
The analysis can be performed in either the Accounting Currency or a standardized currency known as X-Rate. X-Rate translates all balances using the currency rate types and corresponding currency rates of a selected company.
Reporting periods are designed to provide a standardized calendar structure, independent of how individual companies configure their local accounting calendars or define their closing periods. These periods support operational reporting and analysis by ensuring a consistent organizational view across multiple companies.
To facilitate visualizations that cover the entire lifecycle of a project, mixed measures have been introduced. These measures display actuals up to a selected cutoff period while incorporating forecasted values for the remaining periods. To retrieve specific forecast data within mixed measures, users must filter by both the cutoff period and a required forecast type defined for monthly review or for a specific forecast version.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| GENERAL LEDGER MEASURES | N/A | N/A | N/A |
| INTERNAL LEDGER MEASURES | N/A | N/A | N/A |
| DIFF GL vs IL MEASURES | N/A | N/A | N/A |
| FORECAST CUT OFF PERIOD | DIM_BI_TIME_FINANCE_PQ_BI | DIM_BI_TIME_FINANCE_PQ | On Line |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
The Revenue Recognition model has two main sources:
Based on the Information Source FACT_REVENUE_REC_PROJ containing actual amounts.
Based on the Information Source FACT_REV_REC_FORC_LINE_ALL containing forecast amounts.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| FACT ACTUAL AMOUNTS | FACT_REVENUE_REC_PROJ_BI | FACT_REVENUE_REC_PROJ | On Line |
| FORECAST TYPE | DIM_REV_RECOG_FORECAST_TYPE_BI | DIM_REV_RECOG_FORECAST_TYPE | On Line |
| FORECAST VERSION | DIM_REVENUE_REC_FORECAST_BI | DIM_REVENUE_REC_FORECAST | On Line |
| ACCOUNTING PROJECT | DIM_ACCOUNTING_PROJECT_BI | DIM_ACCOUNTING_PROJECT | On Line |
| REPORTING PERIOD | DIM_BI_TIME_FINANCE_PQ_BI | DIM_BI_TIME_FINANCE_PQ | On Line |
| PROJECT PROGRAM | DIM_PROJ_PROGRAM_BI | DIM_PROJ_PROGRAM | On Line |
| COMPANY | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| FACT FORECAST AMOUNTS | FACT_REV_REC_FORC_LINE_ALL_BI | FACT_REV_REC_FORC_LINE_ALL | On Line |
| X-RATE TYPE | DIM_CURR_RATE_TYPE_XRATE_PQ_BI | DIM_CURR_RATE_TYPE_XRATE_PQ | On Line |
| X-RATES | FACT_CURR_RATE_PX_RATE_PQ_BI | FACT_CURR_RATE_PX_RATE_PQ | On Line |
| X-RATE CURRENCY | DIM_CURRENCY_CODE_XRATE_PQ_BI | DIM_CURRENCY_CODE_XRATE_PQ | On Line |
The model assumes that revenue recognition is conducted on a monthly basis.
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| FACT ACTUAL AMOUNTS (DIM_COMPANY_ID) - COMPANY (ID) |
| FACT FORECAST AMOUNTS (DIM_FORECAST_ID) - FORECAST VERSION (ID) |
| FACT FORECAST AMOUNTS (DIM_COMPANY_ID) - COMPANY (ID) |
| FACT FORECAST AMOUNTS (DIM_FORECAST_TYPE_ID) - FORECAST TYPE (ID) |
| FACT ACTUAL AMOUNTS (DIM_PROJECT_ID) - ACCOUNTING PROJECT (ID) |
| X-RATES (TOCURRENCY) - X-RATE CURRENCY (To Currency Code) |
| X-RATES (CURRENCY_RATE_TYPE_KEY) - X-RATE TYPE (Rate Type Code X-Rate) |
| X-RATES (FROMCURRENCY) - X-RATE FROM CURRENCY (From Currency Code) |
| X-RATES (CURRENCY_RATE_DATE_ID) - REPORTING PERIOD (ID) |
| FACT ACTUAL AMOUNTS (COMPANY_BASE_CURRENCY) - X-RATE FROM CURRENCY (From Currency Code) |
| FACT ACTUAL AMOUNTS (DIM_REPORTING_DATE_ID) - REPORTING PERIOD (ID) |
| FACT FORECAST AMOUNTS (COMPANY_BASE_CURRENCY) - X-RATE FROM CURRENCY (From Currency Code) |
| FACT FORECAST AMOUNTS (CUT_OFF_DATE_ID) - FORECAST CUT OFF PERIOD (ID) |
| FACT FORECAST AMOUNTS (ACC_PROJECT_ID) - ACCOUNTING PROJECT (ID) |
| FACT FORECAST AMOUNTS (DIM_REPORTING_DATE_ID) - REPORTING PERIOD (ID) |
| ACCOUNTING PROJECT (Project Program ID) - PROJECT PROGRAM (ID) |
| RR COMPANY RLS (COMPANY) - COMPANY (ID) |